

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<script type="text/javascript" src="helpman_topicinit.js"></script>

<title>PostgreSQL Repository [Enterprise Architect User Guide]</title>

<meta name="keywords" content="Enterprise Architect, Sparx Systems, UML, Model File,Model File Create PostgreSQL Repository,Create,Create PostgreSQL Repository,PostgreSQL,PostgreSQL Repository, Create">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />

<link type="text/css" href="default.css" rel="stylesheet" />
<style type="text/css">
  A, A:Visited
  {
    color: #00F;
  }

  A:Active, A:Hover
  {
    color: #F00;
  }

  OL
  {
    margin: 5px 0 5px 48px;
  }

  UL
  {
    margin-bottom: 3px;
    margin-top: 0;
  }

  #nsr
  {
    background-color: #D4DFFF;
  }

  #nsr A
  {
    text-decoration: none;
  }

  #mainbody
  {
    padding: 8px;
  }

  .p_BodyText
  {
    padding: 5px 0;
  }
</style>



<style type="text/css" media="screen">
  BODY
  {
    background-color: #FFFFFF;
  }

  #nsr
  {
    padding: 6px 6px 0 6px;
    border-bottom: none;
    vertical-align: top;
    z-index: 2;
    visibility: visible;
    left: 0;
    top: 0;
    position: absolute;
  }

  #mainbody
  {
    left: 0;
    top: 0;
    margin: 0;
    position: absolute;
    padding: 10px;
    overflow: auto;
    height: 100%;
    z-index: 1;
    background-repeat: no-repeat;
    background-position: bottom right;
    background-attachment: fixed;
  }
</style>

<style type="text/css" media="print">
  #nsr
  {
    visibility: none;
  }

  #mainbody
  {
    overflow: visible;
  }
</style>
<script type="text/javascript" language="JavaScript" src="nonscroll.js"></script>

</head>
<body scroll="no">

<div id="page">



        <div id="content">
          <div id="content-inner">
          



  
          <div id="nsr">
            <table border="0" cellspacing="0" cellpadding="4" width="100%">
              <tr valign="top">
                <td align="left">
  


                  <p class="p_Heading1"><span class="f_Heading1">PostgreSQL Repository</span></p>



  
                </td>
                <td align="right">
                  <a href="introduction.htm" onmouseover="document.images.main.src='button_main_h.gif'" onmouseout="document.images.main.src='button_main.gif'">
                    <img name="main" src="button_main.gif" border=0 alt="Return to Introduction">
                  </a>&nbsp;
    
                  <a href="createaneworacle9iserverrep.htm" onmouseover="document.images.prev.src='button_prev_h.gif'" onmouseout="document.images.prev.src='button_prev.gif'">
                    <img name=prev src="button_prev.gif" border=0 alt="Previous page" />
                  </a>&nbsp;
    
    
    
                  <a href="createanewadaptiveservera.htm" onmouseover="document.images.next.src='button_next_h.gif'" onmouseout="document.images.next.src='button_next.gif'">
                    <img name=next src="button_next.gif" border=0 alt="Next page" />
                  </a>
    
    
                </td>
              </tr>
            </table>
          </div>
          <div id="mainbody">
  


                <div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 5px 0px 5px 13px;"><table cellspacing="0" cellpadding="2" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:bottom;">
<td valign="bottom" width="955" bgcolor="#efeff7" style="width:955px; background-color:#efeff7;"><p class="p_TiporNote" style="border-top: none; border-right: none; border-left: none;"><span class="f_TiporNote">Note:</span></p>
</td>
</tr>
<tr style="text-align:left;">
<td width="955" bgcolor="#f7f7ff" style="width:955px; background-color:#f7f7ff;"><p class="p_TiporNoteText"><span class="f_TiporNoteText">This feature is available in the </span><span class="f_TiporNoteText">Corporate, Business and Software Engineering, System Engineering and Ultimate editions</span><span class="f_TiporNoteText">.</span></p>
</td>
</tr>
</table>
</div>
<p class="p_BodyText"><span class="f_BodyText">Before creating a PostgreSQL data repository in Enterprise Architect, you must set up PostgreSQL and PostgreSQL ODBC drivers. For further information on setting these up, see <a href="setupapostgresqlodbcdriver.htm">Set up a PostgreSQL ODBC Driver</a>.</span></p>
<p class="p_BodyText"><span class="f_BodyText">To create a new PostgreSQL repository, you must first create a database into which to import the table definitions for Enterprise Architect. Sparx Systems provide SQL scripts to create the required tables; how you create the database and execute that script are up to you.</span></p>
<ul style="text-indent: 0px; margin-left: 30px; list-style-position: outside;">
<li><span class="f_Bulletlist1">Registered users can obtain the scripts from the Registered Corporate edition </span><span class="f_UIControl">Resources</span><span class="f_Bulletlist1"> page of the Sparx Systems website at <a href="http://www.sparxsystems.com/registered/reg_ea_corp_ed.html" target="_blank" class="weblink">www.sparxsystems.com/registered/reg_ea_corp_ed.html</a></span></li>
<li><span class="f_Bulletlist1">Trial users can obtain the scripts from the Corporate edition </span><span class="f_UIControl">Resources</span><span class="f_Bulletlist1"> page of the Sparx Systems website at <a href="http://www.sparxsystems.com/resources/corporate/" target="_blank" class="weblink">http://www.sparxsystems.com/resources/corporate/</a>.</span></li>
</ul>
<p class="p_SubHeadingL1"><span class="f_SubHeadingL1">Create the Data Repository </span></p>
<p class="p_BodyText"><span class="f_BodyText">After you create the database and execute the script, the result should be an empty Enterprise Architect project to begin working with. You can transfer data from an existing .EAP file or simply start from scratch.</span></p>
<p class="p_SubHeadingL2"><span class="f_SubHeadingL2">Third Party Tools </span></p>
<p class="p_BodyText"><span class="f_BodyText">If you are unfamiliar with PostgreSQL and DBMS systems in general, you might want to consider a suitable front end tool.</span></p>
<p class="p_BodyText"><span class="f_BodyText">EMS PostgreSQL Manager is one such tool, and is available at <a href="http://www.sqlmanager.net/products/postgresql/manager" target="_blank" class="weblink">www.sqlmanager.net/products/postgresql/manager</a>. It provides a convenient graphical user interface to enable creation of databases, execution of scripts and restores.</span></p>
<p class="p_BodyText"><span class="f_BodyText">To get started with EMS PostgreSQL Manager, follow the steps below:</span></p>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=1><span class="f_NumberedList">Create a new database.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="postgre-dbwizard.png" width="590" height="341" border="0" alt="Postgre-DBWizard"><br>
<span class="f_NumberedList">&nbsp;</span></li>
<li value=2><span class="f_NumberedList">Open and execute the PostgreSQL sql script.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<span class="f_NumberedList"> <img src="postgresqlscripts.png" width="673" height="436" border="0" alt="PostgreSQLScripts"></span><br>
<span class="f_NumberedList">&nbsp;</span></li>
<li value=3><span class="f_NumberedList">Below is an example showing the tables created in the PostgreSQL repository after running the script in EMS PostgreSQL Manager.</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<span class="f_NumberedList"> <img src="postgreems.png" width="252" height="352" border="0" alt="PostgreEMS"></span></li>
</ol>




            </div>
          </div>
        </div>



</div>


</body>
</html>
